package com.platform.apex.cma.db;

import java.util.List;

import org.skife.jdbi.v2.sqlobject.BindBean;
import org.skife.jdbi.v2.sqlobject.GetGeneratedKeys;
import org.skife.jdbi.v2.sqlobject.SqlBatch;
import org.skife.jdbi.v2.sqlobject.customizers.RegisterMapper;
import org.skife.jdbi.v2.sqlobject.mixins.Transactional;

import com.platform.apex.util.BaseTableInfoMapper;
/**
 * 	   tran_id;worker_id;flow_id;node_id;step_id;detail_id;belong_work;tran_title;timely_time;timely_status;
	  
	   limit_time; attact_qty;  attact_content;create_dept_id;create_dept_name;create_opt_id;create_opt_name;
	  
	   create_opt_time;deal_start_time;deal_part_id; deal_part_name; deal_opt_id;deal_opt_name; deal_opt_time;
	   
	   deal_time;over_status; deal_status;work_status; deal_view; supervise_qty;urge_qty;warn_qty;  opt_order;
	  
	   next_dept;next_persion; pre_tran_id;dispatch_opt_id; dispatch_opt_name;data_resource; data_type; warn_id;
	  
	   warn_title;warn_contant; warn_type; opt_id;opt_name; receive_opt_id;receive_opt_name; opt_time; warn_sort;
	   
	   is_close;close_opt_id; close_opt_name; close_opinion; close_opt_time; supervise_id;supervise_type;supervise_title;
	 
	   supervise_option;is_warn;back_opt_id;back_opt_name; back_status;back_opinion;back_opt_time; is_valid; deal_result;
	   
	   adjust_flow; supervise_level;  remark; urge_id;urge_title; urge_opinion;wish_opt_time; receive_status;receive_opinion;
	  
	   receive_opt_time; deal_opinion;
	  
 * @author eason
 *
 */

@RegisterMapper(BaseTableInfoMapper.class)
public interface MysqlDao extends Transactional<MysqlDao> {

	@SqlBatch("INSERT INTO zhijian_allinone (tran_id,work_id,flow_id,node_id,step_id,detail_id,belong_work,tran_title,timely_time,timely_status,"
			+ "limit_time, attact_qty, attact_content,create_dept_id,create_dept_name,create_opt_id,create_opt_name,"
			+ "create_opt_time,deal_start_time,deal_part_id, deal_part_name, deal_opt_id,deal_opt_name, deal_opt_time,"
			+ "deal_time,over_status, deal_status,work_status, deal_view, supervise_qty,urge_qty,warn_qty,opt_order,"
			+ "next_dept,next_person, pre_tran_id,dispatch_opt_id, dispatch_opt_name,data_resource, data_type, warn_id,"
			+ "warn_title,warn_content, warn_type, opt_id,opt_name, receive_opt_id,receive_opt_name, opt_time, warn_sort,"
			+ "is_close,close_opt_id, close_opt_name, close_opinion, close_opt_time, supervise_id,supervise_type,supervise_title,"
			+ "supervise_opinion,is_warn,back_opt_id,back_opt_name, back_status,back_opinion,back_opt_time, is_valid, deal_result,"
			+ "adjust_flow, supervise_level,remark, urge_id,urge_title, urge_opinion,wish_opt_time,receive_status,receive_opinion,"
			+ "receive_opt_time, deal_opinion)"
			+ " VALUES (:tran_id,:work_id,:flow_id,:node_id,:step_id,:detail_id,:belong_work,:tran_title,:timely_time,:timely_status,"
			+ ":limit_time,:attact_qty, :attact_content,:create_dept_id,:create_dept_name,:create_opt_id,:create_opt_name,"
			+ ":create_opt_time,:deal_start_time,:deal_part_id, :deal_part_name, :deal_opt_id,:deal_opt_name, :deal_opt_time,"
			+ ":deal_time,:over_status, :deal_status,:work_status, :deal_view, :supervise_qty,:urge_qty,:warn_qty,:opt_order,"
			+ ":next_dept,:next_person, :pre_tran_id,:dispatch_opt_id, :dispatch_opt_name,:data_resource, :data_type, :warn_id,"
			+ ":warn_title,:warn_content, :warn_type, :opt_id,opt_name, :receive_opt_id,:receive_opt_name, :opt_time, :warn_sort,"
			+ ":is_close,:close_opt_id, :close_opt_name, :close_opinion, :close_opt_time, :supervise_id,:supervise_type,:supervise_title,"
			+ ":supervise_opinion,:is_warn,:back_opt_id,:back_opt_name, :back_status,:back_opinion,:back_opt_time, :is_valid, :deal_result,"
			+ ":adjust_flow, :supervise_level,:remark, :urge_id,:urge_title, :urge_opinion,:wish_opt_time,:receive_status,:receive_opinion,"
			+ ":receive_opt_time, :deal_opinion)")
	void insert(@BindBean List<AllinOneData> allinOneData);

}